Columns
Constraints
Grants
Statistics
Triggers
Dependencies
Details
Partitions
Indexes
Columns
Constraints
Grants
Statistics
Triggers
Dependencies
Details
Partitions
Indexes
COLUMN_NAME | DATA_TYPE | NULLABLE | DATA_DEFAULT | COLUMN_ID | COMMENTS |
---|---|---|---|---|---|
OBJ | VARCHAR2(20 BYTE) | No | null | 1 | null |
ID | VARCHAR2(100 BYTE) | Yes | null | 2 | null |
TITLE | VARCHAR2(400 BYTE) | Yes | null | 3 | null |
CREATED_ON | DATE | Yes | null | 4 | null |
CREATED_ON_FY | NUMBER | Yes | null | 5 | null |
CLOSED_ON | DATE | Yes | null | 6 | null |
CLOSED_ON_FY | NUMBER | Yes | null | 7 | null |
DAYS_OPEN | NUMBER | Yes | null | 8 | null |
STATUS | VARCHAR2(100 BYTE) | Yes | null | 9 | null |
OWNING_UNIT | VARCHAR2(400 BYTE) | Yes | null | 10 | null |
INCIDENTS | VARCHAR2(4000 BYTE) | Yes | null | 11 | null |
LEAD | VARCHAR2(400 BYTE) | Yes | null | 12 | null |
SUPPORT_PERSONNEL | VARCHAR2(4000 BYTE) | Yes | null | 13 | null |
ASSOCIATIONS_COUNT | NUMBER | Yes | null | 14 | null |
ATTACHMENTS_COUNT | NUMBER | Yes | null | 15 | null |
NOTES_COUNT | NUMBER | Yes | null | 16 | null |
SUBJECT_COUNT | NUMBER | Yes | null | 17 | null |
WITNESS_COUNT | NUMBER | Yes | null | 18 | null |
VICTIM_COUNT | NUMBER | Yes | null | 19 | null |
INCIDENTAL_COUNT | NUMBER | Yes | null | 20 | null |
NEXT_DUE_DATE | DATE | Yes | null | 21 | null |
FINAL_DUE_DATE | DATE | Yes | null | 22 | null |
FINAL_DUE_DATE_FY | NUMBER | Yes | null | 23 | null |
FINAL_DUE_DATE_MET | VARCHAR2(3 BYTE) | Yes | null | 24 | null |
CONSTRAINT_NAME | CONSTRAINT_TYPE | SEARCH_CONDITION | R_OWNER | R_TABLE_NAME | R_CONSTRAINT_NAME | DELETE_RULE | STATUS | DEFERRABLE | VALIDATED | GENERATED | BAD | RELY | LAST_CHANGE | INDEX_OWNER | INDEX_NAME | INVALID | VIEW_RELATED |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SYS_C0095804 | Check | "OBJ" IS NOT NULL | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | GENERATED NAME | null | null | 24-APR-23 | null | null | null | null |
Columns
COLUMN_NAME | COLUMN_POSITION |
---|---|
OBJ | null |
PRIVILEGE | GRANTEE | GRANTABLE | GRANTOR | OBJECT_NAME |
---|
NAME | VALUE |
---|---|
NUM_ROWS | 135 |
BLOCKS | 6 |
AVG_ROW_LEN | 105 |
SAMPLE_SIZE | 135 |
LAST_ANALYZED | 07-FEB-25 |
LAST_ANALYZED_SINCE | 07-FEB-25 |
Column Statistics
TRIGGER_NAME | TRIGGER_TYPE | TRIGGER_OWNER | TRIGGERING_EVENT | STATUS | TABLE_NAME |
---|
OWNER | NAME | TYPE | REFERENCED_OWNER | REFERENCED_NAME | REFERENCED_TYPE |
---|---|---|---|---|---|
QART | V_SIIA_ANALYSIS | VIEW | QART | MV_SIIA_ANALYSIS | TABLE |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_SIIA_ANALYSIS | TABLE |
References
OWNER | NAME | TYPE | REFERENCED_OWNER | REFERENCED_NAME | REFERENCED_TYPE |
---|---|---|---|---|---|
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_ACM_ASSOCIATION | TABLE |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_ACM_ASSOCIATION | MATERIALIZED VIEW |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_F_ANALYSIS | MATERIALIZED VIEW |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_F_ANALYSIS | TABLE |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_F_ANALYSIS_INC | TABLE |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_F_ANALYSIS_INC | MATERIALIZED VIEW |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_SIIA_ANALYSIS | TABLE |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_ACM_OBJ | TABLE |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_ACM_OBJ | MATERIALIZED VIEW |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_ACM_STAKEHOLDER | MATERIALIZED VIEW |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_ACM_OBJ_TYPE | TABLE |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_ACM_STAKEHOLDER_ROLE | TABLE |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_ACM_OBJ_TYPE | MATERIALIZED VIEW |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_ACM_STAKEHOLDER | TABLE |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_ACM_STAKEHOLDER_ROLE | MATERIALIZED VIEW |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | V_CURR_OBJ_LEAD_PERS | VIEW |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_ACM_REFERENCE | TABLE |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | V_CURR_OBJ_OWNING_UNIT | VIEW |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_ACM_REFERENCE | MATERIALIZED VIEW |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_ACM_STATUS_HISTORY | MATERIALIZED VIEW |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_ACM_STATUS | TABLE |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_ACM_STATUS | MATERIALIZED VIEW |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_ACM_STATUS_HISTORY | TABLE |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_PARTIC_ROLE_TYPE | TABLE |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_PARTIC_ROLE_TYPE | MATERIALIZED VIEW |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_ACM_ATTACHMENT | TABLE |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_ACM_ATTACHMENT | MATERIALIZED VIEW |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_ACM_NOTE | TABLE |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_ACM_NOTE | MATERIALIZED VIEW |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_ACM_PLACE | TABLE |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_ACM_PLACE | MATERIALIZED VIEW |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | V_CURR_OBJ_SUPPORT_OFFICER | VIEW |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_PARTIC_INVOLVEMENT | TABLE |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_PARTIC_INVOLVEMENT | MATERIALIZED VIEW |
OWNER | NAME | TYPE | REFERENCED_OWNER | REFERENCED_NAME | REFERENCED_TYPE |
---|---|---|---|---|---|
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_ACM_ASSOCIATION | TABLE |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_ACM_ASSOCIATION | MATERIALIZED VIEW |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_F_ANALYSIS | MATERIALIZED VIEW |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_F_ANALYSIS | TABLE |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_F_ANALYSIS_INC | TABLE |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_F_ANALYSIS_INC | MATERIALIZED VIEW |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_SIIA_ANALYSIS | TABLE |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_ACM_OBJ | TABLE |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_ACM_OBJ | MATERIALIZED VIEW |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_ACM_STAKEHOLDER | MATERIALIZED VIEW |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_ACM_OBJ_TYPE | TABLE |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_ACM_STAKEHOLDER_ROLE | TABLE |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_ACM_OBJ_TYPE | MATERIALIZED VIEW |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_ACM_STAKEHOLDER | TABLE |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_ACM_STAKEHOLDER_ROLE | MATERIALIZED VIEW |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | V_CURR_OBJ_LEAD_PERS | VIEW |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_ACM_REFERENCE | TABLE |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | V_CURR_OBJ_OWNING_UNIT | VIEW |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_ACM_REFERENCE | MATERIALIZED VIEW |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_ACM_STATUS_HISTORY | MATERIALIZED VIEW |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_ACM_STATUS | TABLE |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_ACM_STATUS | MATERIALIZED VIEW |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_ACM_STATUS_HISTORY | TABLE |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_PARTIC_ROLE_TYPE | TABLE |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_PARTIC_ROLE_TYPE | MATERIALIZED VIEW |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_ACM_ATTACHMENT | TABLE |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_ACM_ATTACHMENT | MATERIALIZED VIEW |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_ACM_NOTE | TABLE |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_ACM_NOTE | MATERIALIZED VIEW |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_ACM_PLACE | TABLE |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_ACM_PLACE | MATERIALIZED VIEW |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | V_CURR_OBJ_SUPPORT_OFFICER | VIEW |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_PARTIC_INVOLVEMENT | TABLE |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | MV_PARTIC_INVOLVEMENT | MATERIALIZED VIEW |
NAME | VALUE |
---|---|
CREATED | 24-APR-23 |
LAST_DDL_TIME | 07-FEB-25 |
OWNER | QART |
TABLE_NAME | MV_SIIA_ANALYSIS |
TABLESPACE_NAME | SEARCH |
CLUSTER_NAME | null |
IOT_NAME | null |
STATUS | VALID |
PCT_FREE | 10 |
PCT_USED | null |
INI_TRANS | 1 |
MAX_TRANS | 255 |
INITIAL_EXTENT | 65536 |
NEXT_EXTENT | 1048576 |
MIN_EXTENTS | 1 |
MAX_EXTENTS | 2147483645 |
PCT_INCREASE | null |
FREELISTS | null |
FREELIST_GROUPS | null |
LOGGING | YES |
BACKED_UP | N |
NUM_ROWS | 135 |
BLOCKS | 6 |
EMPTY_BLOCKS | 0 |
AVG_SPACE | 0 |
CHAIN_CNT | 0 |
AVG_ROW_LEN | 105 |
AVG_SPACE_FREELIST_BLOCKS | 0 |
NUM_FREELIST_BLOCKS | 0 |
DEGREE | 1 |
INSTANCES | 1 |
CACHE | N |
TABLE_LOCK | ENABLED |
SAMPLE_SIZE | 135 |
LAST_ANALYZED | 07-FEB-25 |
PARTITIONED | NO |
IOT_TYPE | null |
OBJECT_ID_TYPE | null |
TABLE_TYPE_OWNER | null |
TABLE_TYPE | null |
TEMPORARY | N |
SECONDARY | N |
NESTED | NO |
BUFFER_POOL | DEFAULT |
ROW_MOVEMENT | DISABLED |
GLOBAL_STATS | YES |
USER_STATS | NO |
DURATION | null |
SKIP_CORRUPT | DISABLED |
MONITORING | YES |
CLUSTER_OWNER | null |
DEPENDENCIES | DISABLED |
COMPRESSION | DISABLED |
COMPRESS_FOR | null |
DROPPED | NO |
TABLE_KIND | NORMAL |
PARTITIONING_TYPE | null |
SUBPARTITIONING_TYPE | null |
AUTOLIST | null |
DUPLICATED | N |
SHARDED | N |
COMMENTS | null |
PARTITION_NAME | LAST_ANALYZED | NUM_ROWS | BLOCKS | SAMPLE_SIZE | HIGH_VALUE |
---|
INDEX_OWNER | INDEX_NAME | UNIQUENESS | STATUS | INDEX_TYPE | TEMPORARY | PARTITIONED | FUNCIDX_STATUS | JOIN_INDEX | COLUMNS |
---|